package com.cf.wal.dao;

import com.cf.crud.mapper.BaseMapper;
import com.cf.wal.model.Wal;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface WalDao extends BaseMapper<Wal> {

    @Select("select * from wal where state=#{state}")
    List<Wal> selectByState(@Param("state") String state);

    @Select("select * from wal where sort > #{sort} ")
    List<Wal> selectBySortBigger(@Param("sort") long id);
}
